EMT Practice Test

1. Question Content...

---

Question1: Two users share a virtual warehouse named wh dev 01. When one of the users loads data, the other one experiences performance issues while querying data.
How does Snowflake recommend resolving this issue?

Question2: True or False: It is possible for a user to run a query against the query result cache without requiring an active Warehouse.

Question3: What is a responsibility of Snowflake's virtual warehouses?

Question4: What is a limitation of a Materialized View?

Question5: Which data type can store more than one type of data structure?

Question6: Which of the following describes the Snowflake Cloud Services layer?

Question7: Which of the following accurately describes shares?

Question8: Which command should be used to load data from a file, located in an external stage, into a table in Snowflake?

Question9: A user is loading JSON documents composed of a huge array containing multiple records into Snowflake. The user enables the strip__outer_array file format option What does the STRIP_OUTER_ARRAY file format do?

Question10: What is the purpose of the STRIP NULL_VALUES file format option when loading semi-structured data files into Snowflake?

Question11: Which pages are included in the Activity area of Snowsight? (Select TWO).

Question12: How often are the Account and Table master keys automatically rotated by Snowflake?

Question13: How many days is load history for Snowpipe retained?

Question14: True or False: Loading data into Snowflake requires that source data files be no larger than 16MB.

Question15: Files have been uploaded to a Snowflake internal stage. The files now need to be deleted.
Which SQL command should be used to delete the files?

Question16: What is the recommended compressed file size range for continuous data loads using Snowpipe?

Question17: What effect does WAIT_FOR_COMPLETION = TRUE have when running an ALTER WAREHOUSE command and changing the warehouse size?

Question18: Which cache type is used to cache data output from SQL queries?

Question19: When reviewing the load for a warehouse using the load monitoring chart, the chart indicates that a high volume of Queries are always queuing in the warehouse According to recommended best practice, what should be done to reduce the Queue volume? (Select TWO).

Question20: What is the following SQL command used for?
Select * from table(validate(t1, job_id => '_last'));

Question21: How many network policies can be assigned to an account or specific user at a time?

Question22: How should clustering be used to optimize the performance of queries that run on a very large table?

Question23: What is the MAXIMUM size limit for a record of a VARIANT data type?

Question24: Which object can be used with Secure Data Sharing?

Question25: Which privilege must be granted to a share to allow secure views the ability to reference data in multiple databases?

Question26: Which parameter can be set at the account level to set the minimum number of days for which Snowflake retains historical data in Time Travel?

Question27: What is the default character set used when loading CSV files into Snowflake?

Question28: Which Snowflake URL type is used by directory tables?

Question29: What privilege should a user be granted to change permissions for new objects in a managed access schema?

Question30: When publishing a Snowflake Data Marketplace listing into a remote region what should be taken into consideration? (Choose two.)

Question31: A tabular User-Defined Function (UDF) is defined by specifying a return clause that contains which keyword?

Question32: Snowflake's hierarchical key mode includes which keys? (Select TWO).

Question33: What statistical information in a Query Profile indicates that the query is too large to fit in memory? (Select TWO).

Question34: Which database objects can be shared with the Snowflake secure data sharing feature? (Choose two.)

Question35: What happens to historical data when the retention period for an object ends?

Question36: A Snowflake user has been granted the create data EXCHANGE listing privilege with their role.
Which tasks can this user now perform on the Data Exchange? (Select TWO).

Question37: Will data cached in a warehouse be lost when the warehouse is resized?

Question38: Which command is used to unload data from a Snowflake database table into one or more files in a Snowflake stage?

Question39: Which of the following statements describe features of Snowflake data caching? (Choose two.)

Question40: Which semi-structured data function interprets an input string as a JSON document that produces a VARIANT value?

Question41: Which Snowflake command can be used to unload the result of a query to a single file?

Question42: Which REST API can be used with unstructured data?

Question43: Which of the following is an example of an operation that can be completed without requiring compute, assuming no queries have been executed previously?

Question44: Which statistics can be used to identify queries that have inefficient pruning? (Select TWO).

Question45: User-level network policies can be created by which of the following roles? (Select TWO).

Question46: What factors impact storage costs in Snowflake? (Select TWO).

Question47: What is the purpose of an External Function?

Question48: What tasks can an account administrator perform in the Data Exchange? (Select TWO).

Question49: How does Snowflake recommend handling the bulk loading of data batches from files already available in cloud storage?

Question50: Which Snowflake feature allows a user to track sensitive data for compliance, discovery, protection, and resource usage?

Question51: A company strongly encourages all Snowflake users to self-enroll in Snowflake's default Multi-Factor Authentication (MFA) service to provide increased login security for users connecting to Snowflake.
Which application will the Snowflake users need to install on their devices in order to connect with MFA?

Question52: A JSON file, that contains lots of dates and arrays, needs to be processed in Snowflake. The user wants to ensure optimal performance while querying the data.
How can this be achieved?

Question53: Who can activate and enforce a network policy for all users in a Snowflake account? (Select TWO).

Question54: In the Snowflake access control model, which entity owns an object by default?

Question55: The Snowflake Cloud Data Platform is described as having which of the following architectures?

Question56: What occurs when a pipe is recreated using the CREATE OR REPLACE PIPE command?

Question57: A Snowflake Administrator needs to ensure that sensitive corporate data in Snowflake tables is not visible to end users, but is partially visible to functional managers.
How can this requirement be met?

Question58: What is the SNOWFLAKE.ACCOUNT_USAGE view that contains information about which objects were read by queries within the last 365 days (1 year)?

Question59: What does the LATERAL modifier for the FLATTEN function do?

Question60: By definition, a secure view is exposed only to users with what privilege?

Question61: A sales table FCT_SALES has 100 million records.
The following Query was executed
SELECT COUNT (1) FROM FCT__SALES;
How did Snowflake fulfill this query?

Question62: What are the least privileges needed to view and modify resource monitors? (Select TWO).

Question63: How can a Snowflake user traverse semi-structured data?

Question64: Which file formats are supported for unloading data from Snowflake? (Choose two.)

Question65: A Snowflake account has activated federated authentication.
What will occur when a user with a password that was defined by Snowflake attempts to log in to Snowflake?

Question66: When loading data into Snowflake via Snowpipe what is the compressed file size recommendation?

Question67: Which file format will keep floating-point numbers from being truncated when data is unloaded?

Question68: Which type of join will list a I rows in the specified table, even if those rows have no match in the other table?

Question69: What is the minimum Snowflake edition required for row level security?

Question70: A developer is granted ownership of a table that has a masking policy. The developer's role is not able to see the masked data. Will the developer be able to modify the table to read the masked data?

Question71: What will prevent unauthorized access to a Snowflake account from an unknown source?

Question72: When should a user consider disabling auto-suspend for a virtual warehouse? (Select TWO).

Question73: Which Snowflake function is maintained separately from the data and helps to support features such as Time Travel, Secure Data Sharing, and pruning?

Question74: What is the MINIMUM edition of Snowflake that is required to use a SCIM security integration?

Question75: Which statement describes how Snowflake supports reader accounts?

Question76: What are common issues found by using the Query Profile? (Choose two.)

Question77: User INQUISITIVE_PERSON has been granted the role DATA_SCIENCE. The role DATA_SCIENCE has privileges OWNERSHIP on the schema MARKETING of the database ANALYTICS_DW.
Which command will show all privileges granted to that schema?

Question78: What function can be used with the recursive argument to return a list of distinct key names in all nested elements in an object?

Question79: What happens when a Snowflake user changes the data retention period at the schema level?

Question80: What are ways to create and manage data shares in Snowflake? (Select TWO)

Question81: Which of the following can be executed/called with Snowpipe?

Question82: What COPY INTO SQL command should be used to unload data into multiple files?

Question83: When using the ALLOW CLIENT_MFA_CACHING parameter, how long is a cached Multi-Factor Authentication (MFA) token valid for?

Question84: In a Snowflake role hierarchy, what is the top-level role?

Question85: Which commands are restricted in owner's rights stored procedures? (Select TWO).

Question86: A user with which privileges can create or manage other users in a Snowflake account? (Select TWO).

Question87: Which statements reflect key functionalities of a Snowflake Data Exchange? (Choose two.)

Question88: What are key characteristics of virtual warehouses in Snowflake? (Select TWO).

Question89: Which TABLE function helps to convert semi-structured data to a relational representation?

Question90: Which user object property requires contacting Snowflake Support in order to set a value for it?

Question91: Which of the following activities consume virtual warehouse credits in the Snowflake environment? (Choose two.)

Question92: During periods of warehouse contention which parameter controls the maximum length of time a warehouse will hold a query for processing?

Question93: Which Snowflake feature provides increased login security for users connecting to Snowflake that is powered by Duo Security service?

Question94: Where is Snowflake metadata stored?

Question95: True or False: When you create a custom role, it is a best practice to immediately grant that role to ACCOUNTADMIN.

Question96: How long is the Fail-safe period for temporary and transient tables?

Question97: What does Snowflake's search optimization service support?

Question98: Which operation can be performed on Snowflake external tables?

Question99: What is the name of the SnowSQLfile that can store connection information?

Question100: Which formats does Snowflake store unstructured data in? (Choose two.)

Question101: Which function unloads data from a relational table to JSON?

Question102: A materialized view should be created when which of the following occurs? (Choose two.)

Question103: What step can reduce data spilling in Snowflake?

Question104: A company needs to read multiple terabytes of data for an initial load as part of a Snowflake migration. The company can control the number and size of CSV extract files.
How does Snowflake recommend maximizing the load performance?

Question105: Which Snowflake function will interpret an input string as a JSON document, and produce a VARIANT value?

Question106: While working with unstructured data, which file function generates a Snowflake-hosted file URL to a staged file using the stage name and relative file path as inputs?

Question107: If 3 size Small virtual warehouse is made up of two servers, how many servers make up a Large warehouse?

Question108: What type of query will benefit from the query acceleration service?

Question109: What impacts the credit consumption of maintaining a materialized view? (Choose two.)

Question110: What is used to diagnose and troubleshoot network connections to Snowflake?

Question111: What technique does Snowflake use to limit the number of micro-partitions scanned by each query?

Question112: Which Snowflake table objects can be shared with other accounts? (Select TWO).

Question113: What objects in Snowflake are supported by Dynamic Data Masking? (Select TWO).'

Question114: Which Snowflake layer is always leveraged when accessing a query from the result cache?

Question115: What can be used to view warehouse usage over time? (Select Two).

Question116: What happens when an external or an internal stage is dropped? (Select TWO).

Question117: When enabling access to unstructured data, which URL permits temporary access to a staged file without the need to grant privileges to the stage or to issue access tokens?

Question118: What happens to the shared objects for users in a consumer account from a share, once a database has been created in that account?

Question119: Which snowflake objects will incur both storage and cloud compute charges? (Select TWO)

Question120: Which is the MINIMUM required Snowflake edition that a user must have if they want to use AWS/Azure Privatelink or Google Cloud Private Service Connect?

Question121: Which items are considered schema objects in Snowflake? (Select TWO).

Question122: The Snowflake Search Optimization Services supports improved performance of which kind of query?

Question123: What happens when a cloned table is replicated to a secondary database? (Select TWO)

Question124: What happens to the underlying table data when a CLUSTER BY clause is added to a Snowflake table?

Question125: What does SnowCD help Snowflake users to do?

Question126: How do Snowflake data providers share data that resides in different databases?

Question127: What is a key feature of Snowflake architecture?

Question128: What is the recommended file sizing for data loading using Snowpipe?

Question129: What Snowflake feature provides a data hub for secure data collaboration, with a selected group of invited members?

Question130: A user wants to access files stored in a stage without authenticating into Snowflake. Which type of URL should be used?

Question131: What tasks can be completed using the copy command? (Select TWO)

Question132: A user has 10 files in a stage containing new customer data. The ingest operation completes with no errors, using the following command:
COPY INTO my__table FROM @my__stage;
The next day the user adds 10 files to the stage so that now the stage contains a mixture of new customer data and updates to the previous data. The user did not remove the 10 original files.
If the user runs the same copy into command what will happen?

Question133: Which of the following describes how multiple Snowflake accounts in a single organization relate to various cloud providers?

Question134: What is the MOST performant file format for loading data in Snowflake?

Question135: When reviewing a query profile, what is a symptom that a query is too large to fit into the memory?

Question136: At what levels can a resource monitor be configured? (Select TWO).

Question137: Which of the following features are available with the Snowflake Enterprise edition? (Choose two.)

Question138: Which Snowflake architectural layer is responsible for a query execution plan?

Question139: What types of data listings are available in the Snowflake Data Marketplace? (Choose two.)

Question140: Why does Snowflake recommend file sizes of 100-250 MB compressed when loading data?

Question141: Which Snowflake role can manage any object grant globally, including modifying and revoking grants?

Question142: Which Snowflake technique can be used to improve the performance of a query?

Question143: Which ACCOUNT_USAGE schema database role provides visibility into policy-related information?

Question144: Which of the following are considerations when using a directory table when working with unstructured data?
(Choose two.)

Question145: What is cached during a query on a virtual warehouse?

Question146: Which Snowflake feature allows administrators to identify unused data that may be archived or deleted?

Question147: What type of query benefits the MOST from search optimization?

Question148: What happens to the objects in a reader account when the DROP MANAGED ACCOUNT command is executed?

Question149: Which statements are correct concerning the leveraging of third-party data from the Snowflake Data Marketplace? (Choose two.)

Question150: Which Snowflake partner specializes in data catalog solutions?

Question151: How can a dropped internal stage be restored?

Question152: What can a Snowflake user do in the Admin area of Snowsight?

Question153: What versions of Snowflake should be used to manage compliance with Personal Identifiable Information (PII) requirements? (Choose two.)

Question154: What service is provided as an integrated Snowflake feature to enhance Multi-Factor Authentication (MFA) support?

Question155: In which use cases does Snowflake apply egress charges?

Question156: Which Snowflake URL type allows users or applications to download or access files directly from Snowflake stage without authentication?

Question157: What is an advantage of using an explain plan instead of the query profiler to evaluate the performance of a query?

Question158: Which of the following compute resources or features are managed by Snowflake? (Select TWO).

Question159: Which command is used to start configuring Snowflake for Single Sign-On (SSO)?

Question160: What SQL command would be used to view all roles that were granted to user.1?

Question161: How should a virtual warehouse be configured if a user wants to ensure that additional multi-clusters are resumed with no delay?

Question162: What is the maximum total Continuous Data Protection (CDP) charges incurred for a temporary table?

Question163: Which data types can be used in Snowflake to store semi-structured data? (Select TWO)

Question164: How long does Snowflake retain information in the ACCESS HISTORY view?

Question165: True or False: Reader Accounts are able to extract data from shared data objects for use outside of Snowflake.

Question166: Which command should be used to download files from a Snowflake stage to a local folder on a client's machine?

Question167: Which query contains a Snowflake hosted file URL in a directory table for a stage named bronzestage?

Question168: Which statement MOST accurately describes clustering in Snowflake?

Question169: What is a machine learning and data science partner within the Snowflake Partner Ecosystem?

Question170: Which Snowflake tool would be BEST to troubleshoot network connectivity?

Question171: What is the primary purpose of a directory table in Snowflake?

Question172: How can a Snowflake user optimize query performance in Snowflake? (Select TWO).

Question173: A column named "Data" contains VARIANT data and stores values as follows:

How will Snowflake extract the employee's name from the column data?

Question174: Which semi-structured file formats are supported when unloading data from a table? (Select TWO).

Question175: What actions will prevent leveraging of the ResultSet cache? (Choose two.)

Question176: Which of the following indicates that it may be appropriate to use a clustering key for a table? (Select TWO).

Question177: Which of the following describes external functions in Snowflake?

Question178: How does Snowflake handle the bulk unloading of data into single or multiple files?

Question179: A virtual warehouse is created using the following command:
Create warehouse my_WH with
warehouse_size = MEDIUM
min_cluster_count = 1
max_cluster_count = 1
auto_suspend = 60
auto_resume = true;
The image below is a graphical representation of the warehouse utilization across two days.

What action should be taken to address this situation?

Question180: What is a characteristic of the Snowflake Query Profile?

Question181: A view is defined on a permanent table. A temporary table with the same name is created in the same schema as the referenced table. What will the query from the view return?

Question182: What is the minimum Snowflake edition that has column-level security enabled?

Question183: What is the recommended way to change the existing file format type in my format from CSV to JSON?

Question184: The is the minimum Fail-safe retention time period for transient tables?

Question185: What MINIMUM privilege is required on the external stage for any role in the GET REST API to access unstructured data files using a file URL?

Question186: How is unstructured data retrieved from data storage?

Question187: Which Snowflake SQL statement would be used to determine which users and roles have access to a role called MY_ROLE?

Question188: True or False: Fail-safe can be disabled within a Snowflake account.

Question189: What action can a user take to address query concurrency issues?

Question190: Which command can be used to load data into an internal stage?